<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" Inherits="AdHocReports.step6" Title="Untitled Page" Codebehind="step6.aspx.cs" %>
<asp:Content ID="Content1" ContentPlaceHolderID="contentBody" Runat="Server">
    Setup filters to establish your report criteria.<br />
    <br />
    <table>
        <tr>
            <td colspan="4">
                <asp:DropDownList ID="cboFilters" runat="server" AutoPostBack="True" OnSelectedIndexChanged="cboFilters_SelectedIndexChanged">
                    <asp:ListItem Value="0">Show Numeric Filters</asp:ListItem>
                    <asp:ListItem Value="1">Show Date/Time Filters</asp:ListItem>
                    <asp:ListItem Value="2">Show String Filters</asp:ListItem>
                    <asp:ListItem Value="3">Show True/False Filters</asp:ListItem>
                </asp:DropDownList></td>
        </tr>
        <tr id="trNumeric" runat="server">
            <td>
                Available Columns:<br />
                <asp:ListBox ID="lstNumeric" runat="server" AutoPostBack="True" OnSelectedIndexChanged="lstNumeric_SelectedIndexChanged"></asp:ListBox></td>
            <td>
                Filter Choices:<br />
                <asp:DropDownList ID="cboNumericOps" runat="server" AutoPostBack="True" Enabled="False"
                    OnSelectedIndexChanged="cboNumericOps_SelectedIndexChanged">
                    <asp:ListItem Value="is any value">is any value</asp:ListItem>
                    <asp:ListItem Value="=">is equal to</asp:ListItem>
                    <asp:ListItem Value="&lt;&gt;">is not equal to</asp:ListItem>
                    <asp:ListItem Value="IN">is one of</asp:ListItem>
                    <asp:ListItem Value="NOT IN">is not one of</asp:ListItem>
                    <asp:ListItem Value="&lt;">is less than</asp:ListItem>
                    <asp:ListItem Value="&lt;=">is less than or equal to</asp:ListItem>
                    <asp:ListItem Value="&gt;">is greater than</asp:ListItem>
                    <asp:ListItem Value="&gt;=">is greather than or equal to</asp:ListItem>
                </asp:DropDownList><br />
                <asp:TextBox ID="txtNumericOps" runat="server" Enabled="False"></asp:TextBox><asp:Button
                    ID="cmdAddNumericRange" runat="server" Enabled="False" OnClick="cmdAddNumericRange_Click"
                    Text="\/" /><br />
                <asp:ListBox ID="lstNumericOps" runat="server" Enabled="False" Width="154px"></asp:ListBox></td>
            <td valign="center">
                <asp:Button ID="cmdMoveRightNumeric" runat="server" OnClick="cmdMoveRightNumeric_Click"
                    Text=" >> " /><br />
                <br />
                <asp:Button ID="cmdMoveLeftNumeric" runat="server" OnClick="cmdMoveLeftNumeric_Click"
                    Text=" << " /></td>
            <td>
                Selected Filters:<br />
                <asp:ListBox ID="lstNumericFilters" runat="server" AutoPostBack="True"></asp:ListBox></td>
        </tr>
        <tr id="trDateTime" runat="server">
            <td>
                Available Columns:<br />
                <asp:ListBox ID="lstDateTime" runat="server" AutoPostBack="True" OnSelectedIndexChanged="lstDateTime_SelectedIndexChanged"></asp:ListBox></td>
            <td>
                Filter Choices:<br />
                <asp:DropDownList ID="cboDateTimeOps" runat="server" AutoPostBack="True" Enabled="False"
                    OnSelectedIndexChanged="cboDateTimeOps_SelectedIndexChanged">
                    <asp:ListItem Value="is any value">is any value</asp:ListItem>
                    <asp:ListItem Value="=">is equal to</asp:ListItem>
                    <asp:ListItem Value="&lt;&gt;">is not equal to</asp:ListItem>
                    <asp:ListItem Value="IN">is one of</asp:ListItem>
                    <asp:ListItem Value="NOT IN">is not one of</asp:ListItem>
                    <asp:ListItem Value="&lt;">is less than</asp:ListItem>
                    <asp:ListItem Value="&lt;=">is less than or equal to</asp:ListItem>
                    <asp:ListItem Value="&gt;">is greater than</asp:ListItem>
                    <asp:ListItem Value="&gt;=">is greather than or equal to</asp:ListItem>
                    <asp:ListItem Value="BETWEEN">is between</asp:ListItem>
                    <asp:ListItem Value="NOT BETWEEN">is not between</asp:ListItem>
                </asp:DropDownList><br />
                <asp:ImageButton ID="cmdCal" runat="server" ImageUrl="images/cal.jpg" OnClick="cmdCal_Click" />
                <asp:TextBox ID="txtDateTimeOps" runat="server" Enabled="False" Width="134px"></asp:TextBox><asp:Button
                    ID="cmdAddDateTimeRange" runat="server" Enabled="False" OnClick="cmdAddDateTimeRange_Click"
                    Text="\/" /><br />
                <asp:ListBox ID="lstDateTimeOps" runat="server" Enabled="False" Width="154px"></asp:ListBox></td>
            <td valign="center">
                <asp:Button ID="cmdMoveRightDateTime" runat="server" OnClick="cmdMoveRightDateTime_Click"
                    Text=" >> " /><br />
                <br />
                <asp:Button ID="cmdMoveLeftDateTime" runat="server" OnClick="cmdMoveLeftDateTime_Click"
                    Text=" << " /></td>
            <td>
                Selected Filters:<br />
                <asp:ListBox ID="lstDateTimeFilters" runat="server" AutoPostBack="True"></asp:ListBox></td>
        </tr>
        <tr id="trString" runat="server">
            <td>
                Available Columns:<br />
                <asp:ListBox ID="lstString" runat="server" AutoPostBack="True" OnSelectedIndexChanged="lstString_SelectedIndexChanged"></asp:ListBox></td>
            <td>
                Filter Choices:<br />
                <asp:DropDownList ID="cboStringOps" runat="server" AutoPostBack="True" Enabled="False"
                    OnSelectedIndexChanged="cboStringOps_SelectedIndexChanged">
                    <asp:ListItem Value="is any value">is any value</asp:ListItem>
                    <asp:ListItem Value="=">is equal to</asp:ListItem>
                    <asp:ListItem Value="&lt;&gt;">is not equal to</asp:ListItem>
                    <asp:ListItem Value="IN">is one of</asp:ListItem>
                    <asp:ListItem Value="NOT IN">is not one of</asp:ListItem>
                    <asp:ListItem Value="LIKE '_%'">starts with</asp:ListItem>
                    <asp:ListItem Value="LIKE '%_'">ends with</asp:ListItem>
                    <asp:ListItem Value="LIKE '%_%'">does contain</asp:ListItem>
                    <asp:ListItem Value="NOT LIKE '%_%'">does not contain</asp:ListItem>
                </asp:DropDownList><br />
                <asp:TextBox ID="txtStringOps" runat="server" Enabled="False"></asp:TextBox><asp:Button
                    ID="cmdAddStringRange" runat="server" Enabled="False" OnClick="cmdAddStringRange_Click"
                    Text="\/" /><br />
                <asp:ListBox ID="lstStringOps" runat="server" Enabled="False" Width="154px"></asp:ListBox></td>
            <td valign="center">
                <asp:Button ID="cmdMoveRightString" runat="server" OnClick="cmdMoveRightString_Click"
                    Text=" >> " /><br />
                <br />
                <asp:Button ID="cmdMoveLeftString" runat="server" OnClick="cmdMoveLeftString_Click"
                    Text=" << " /></td>
            <td>
                Selected Filters:<br />
                <asp:ListBox ID="lstStringFilters" runat="server" AutoPostBack="True"></asp:ListBox></td>
        </tr>
        <tr id="trBoolean" runat="server">
            <td>
                Available Columns:<br />
                <asp:ListBox ID="lstBoolean" runat="server" AutoPostBack="True" OnSelectedIndexChanged="lstBoolean_SelectedIndexChanged"></asp:ListBox></td>
            <td>
                Fitler Choices:<br />
                <asp:DropDownList ID="cboBooleanOps" runat="server" Enabled="False">
                    <asp:ListItem Value="is any value">is any value</asp:ListItem>
                    <asp:ListItem Value="1">is true</asp:ListItem>
                    <asp:ListItem Value="0">is false</asp:ListItem>
                </asp:DropDownList></td>
            <td valign="center">
                <asp:Button ID="cmdMoveRightBoolean" runat="server" OnClick="cmdMoveRightBoolean_Click"
                    Text=" >> " /><br />
                <br />
                <asp:Button ID="cmdMoveLeftBoolean" runat="server" OnClick="cmdMoveLeftBoolean_Click"
                    Text=" << " /></td>
            <td>
                Selected Filters:<br />
                <asp:ListBox ID="lstBooleanFilters" runat="server" AutoPostBack="True"></asp:ListBox></td>
        </tr>
        <tr>
            <td colspan="4">
                <asp:Button ID="cmdTest" runat="server" Text=" Test " OnClick="cmdTest_Click" />
                This query will return
                <asp:Label ID="lblQueryRowCount" runat="server">0</asp:Label>
                rows.</td>
        </tr>
        <tr>
            <td colspan="4">
            </td>
        </tr>
    </table>
</asp:Content>

